alter table SK_EXPERIENCE add PERIOD2 VARCHAR2(255);
alter table SK_TOWN add PROCESS VARCHAR2(255) default '0';
alter table SK_APPLY_FINANCE add HAS_REPORT VARCHAR2(255) default '0';
alter table SK_APPLY_FINANCE add REPORT_START VARCHAR2(255);
alter table SK_APPLY_FINANCE add REPORT_END VARCHAR2(255);

insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_townImport', '', '/console/recruit/townImport.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_townImport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);

insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyPlanReport', '', '/console/recruit/applyPlanReport.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (5, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyPlanReport', '规划统计报表', 'action', '/console/recruit/applyPlanReport.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
